﻿CREATE PROCEDURE [dbo].[Task_Create]
	@Summary nvarchar(200),
	@Description nvarchar(max),
	@ProjectId int,
	@StatusId int,
	@AssignedUserId int,
	@CreatedUserId int,
	@Priority tinyint,
	@CategoryId int,
	@ViewStatus tinyint,
	@StartDate datetime,
	@EndDate datetime
AS
BEGIN
	insert into Task (Summary, [Description], ProjectId, StatusId, AssignedUserId, CreatedUserId, [Priority], CategoryId, ViewStatus, StartDate, EndDate)
	values (@Summary, @Description, @ProjectId, @StatusId, @AssignedUserId, @CreatedUserId, @Priority, @CategoryId, @ViewStatus, @StartDate, @EndDate)

	select SCOPE_IDENTITY()
END